<?php

namespace app\admin\controller;

use app\admin\model\IncomeLogModel;
use app\common\controller\Adminbase;
use think\Db;
use think\Exception;

/**
 * 项目管理
 */
class Project extends Adminbase
{

    /**
     * ProjectModel模型对象
     * @var \app\admin\model\ProjectModel
     */
    protected $modelClass = null;

    protected function initialize()
    {
        parent::initialize();
        $this->modelClass = new \app\admin\model\ProjectModel;

    }

    /**
     * 默认生成的控制器所继承的父类中有index/add/edit/del/multi五个基础方法、destroy/restore/recyclebin三个回收站方法
     * 因此在当前控制器中可不用编写增删改查的代码,除非需要自己控制这部分逻辑
     * 需要将application/admin/library/traits/Curd.php中对应的方法复制到当前控制器,然后进行修改
     */


    /**
     * 查看
     */
    public function index()
    {
        //当前是否为关联查询
        $this->relationSearch = true;
        //设置过滤方法
        $this->request->filter(['strip_tags', 'trim']);
        if ($this->request->isAjax()) {
            //如果发送的来源是Selectpage，则转发到Selectpage
            if ($this->request->request('keyField')) {
                return $this->selectpage();
            }
            [$page, $limit, $where, $sort, $order] = $this->buildTableParames();

            $list = $this->modelClass
                    ->withJoin(['custom'])
                    ->where($where)
                    ->order($sort, $order)
                    ->paginate($limit);
            foreach ($list as $row) {
                $row->getRelation('custom')->visible(['username','phone']);
            }

            $totalMoney =  $this->modelClass->withJoin(['custom'])->where($where)->sum('total_money');

            $shijiMoney = $this->modelClass->withJoin(['custom'])->where($where)->column('yzn_project.id');

            $shijiMoney = (new IncomeLogModel())->where(['pid' => $shijiMoney])->sum('money');

            $result = ["code" => 0, "count" => $list->total(), "data" => $list->items(),'totalMoney' => $totalMoney,'shijiMoney' => $shijiMoney];

            return json($result);
        }
        return $this->fetch();
    }


    public function add()
    {
        if ($this->request->isPost()) {
            $params             = $this->request->post('row');
            try {
                Db::startTrans();
                $this->modelClass->allowField(true)->save($params);

                $method = $params['method'];
                if(!$method){
                   throw new Exception('请填写付款类型');
                }
                foreach ($method as $key => &$value) {
                    $value['pid'] =  $this->modelClass->id;
                    $value['title'] =  $value['key'];
                    $value['money'] =  $value['value'];
                    (new IncomeLogModel())->save($value);
                }
                Db::commit();
            } catch (\Exception $e) {
                Db::rollback();
                $this->error($e->getMessage());
            }
            $this->success("添加成功！", url('index'));
        }
        return $this->fetch();
    }

    public function edit()
    {
        $id = $this->request->param('id/d', 0);
        $row = $this->modelClass->get($id);
        if ($this->request->isPost()) {
            $params = $this->request->post('row');
            Db::startTrans();
            try {
                $row->allowField(true)->save($params);
                $method = json_decode($params['method'], true);
                if(!(new IncomeLogModel())->where(['pid' => $id])->delete()){
                    throw new Exception('Cannot delete');
                }
                foreach ($method as $key => &$value) {
                    $arr['pid'] =  $id;
                    $arr['title'] =  $key;
                    $arr['money'] =  $value;
                    (new IncomeLogModel())->save($arr);
                }
                Db::commit();

            } catch (\Exception $e) {
                Db::rollback();
                $this->error($e->getMessage());
            }
            $this->success("修改成功！");
        }
        $method = (new IncomeLogModel())->where(['pid' => $id])
            ->field('id, pid, title as `key`, money as value')
            ->select()->toArray();
        $row['lists'] =json_encode(array_column($method,'value','key'),JSON_UNESCAPED_UNICODE);
        $this->assign('data', $row);
        return $this->fetch();
    }


}
